Dashboarding and Reporting with Power Pivot and Excel: How to Design and Create a Financial Dashboard with PowerPivot – End to End by Kasper de Jonge

Author:Kasper de Jonge [de Jonge, Kasper]
Language: eng
Format: mobi
Publisher: Holy Macro! Books
Published: 2014-07-14T16:00:00+00:00

Figure 4.36: Adding a PivotChart.

To optimize his space, Jim decides to remove the field buttons. He removes the field buttons by selecting Analyze, Field Button, Hide All. Jim also decided to change the chart style to a line chart.

Dashboard Tip: Choosing the Right Chart

Choosing the right chart to show data might be the hardest problem in data visualization. Unfortunately, there is no surefire way to choose the right chart. It depends on many, many factors—and on the data you want to show. You have to think about what information you want to show and what information is important. The core idea behind graphs and charts is that they help people understand data quickly and allow you to tell the story behind the data. Therefore, an important factor in choosing and designing the right chart is having a good understanding of the data and the types of charts.

There are four core types of chart visualizations: those that show the distribution of data points, those that make a comparison between data points, those that show the relationships between data points, and those that show how data points are put together (composition). These visualizations help your audience see what you are talking about.

Let’s look at an example for each type:

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.